Client Profit
The Client Profit report gives the firm an overall picture of profitability for each client, showing production costs, expenses, invoiced amounts, and overall profit.
Permissions Required for this Report
In the staff profile, staff must be assigned to a security group that is granted View functional rights for the following:
- Security group profile > Functional rights > Reports > Shared Library > Shared Views
- Security group profile > Functional rights > Reports > Firm Library > Custom
- Security group profile > Functional rights > Reports > Firm Library > Standard > Firm
- Security group profile > Functional rights > Reports > Firm Library > Standard > Practice
- Security group profile > Functional rights > Reports > Firm Library > <report name>
- Security group profile > Functional rights > Administration Manager > Client Manager > Approved Clients
Reports in Foundation that are Comparable
In Practice Management, the comparable report is Client Profit. In Practice Advantage, there is no comparable report.
Report Specifications
The following report options and filters are available to determine the report contents.
Options and Settings | ||
---|---|---|
Option | Setting | Description |
Include Write Up/Down in Time and Expense Amounts |
Yes/No |
Includes write-ups and write-downs in time and expense calculations. |
Hide Comma |
Yes/No |
Includes or excludes comma in numbers. |
Hide Penny |
Yes/No |
Includes or excludes pennies in amounts. |
Default Filters | ||
---|---|---|
Field Name | Operator | Value |
Transaction Date |
Between |
First Day Of Current Fiscal Year, Last Day Of Current Fiscal Year |
Status |
= |
All |
Optional Filters | ||
---|---|---|
Available Fields | ||
Accounting Period Date |
Client Region | Primary Partner |
Billed Hours |
Client Sub ID | Profit % |
Business Code |
Client Type |
Real % |
Client |
Effective Rate | Return Group |
Client – Principal |
Expenses Cost |
Status |
Client Bill Manager |
Expenses Invoiced | Tax Type |
Client Business Unit |
Financial Reporting Client Group | Time Cost |
Client ID |
Gross Profit | Time Invoiced |
Client ID.Sub ID |
Invoices w/o Progress | Total Cost |
Client Name |
Line of Business | Transaction Date |
Client Office |
Manager |
|
Client Primary Service Type | Posted Date |
Grouping | ||
---|---|---|
Available Fields | ||
Business Code |
Client Name |
Financial Reporting Client Group |
Client – Principal |
Client Office |
Line of Business |
Client Bill Manager |
Client Primary Service Type |
Manager |
Client Business Unit |
Client Region |
Primary Partner |
Client ID |
Client Sub ID |
Return Group |
Client ID.Sub ID |
Client Type |
Tax Type |
Sorting | ||
---|---|---|
Available Fields | ||
Billed Hours |
Expenses Invoiced |
Time Cost |
Client ID |
Gross Profit |
Time Invoiced |
Client Name |
Invoiced w/o Progress |
Total Cost |
Effective Rate |
Profit % |
|
Expenses Cost |
Real % |
|
Report Fields
The following fields are available for this report. The fields that display and the position of fields are based on the report's settings, grouping, sorting, and filters.
Report Fields | |
---|---|
Field | Description |
Client ID |
The client ID. |
Client Name |
The client name. |
Billed Hours |
The total hours for billed WIP on posted invoices for the date range selected. |
Time Invoiced |
The total WIP time amounts billed including write up/down without progress. This amount includes surcharges that have been billed. |
Time Cost |
The cost rate per staff for billed WIP multiplied by the number of hours billed. |
Expenses Invoices |
The total of expenses billed on posted invoices for the date range selected including write up/down. |
Expenses Cost |
The original expense amount. |
Invoiced w/o Progress |
The total billed WIP + write up/down without progress. |
Total Cost |
The sum of time cost plus expense cost. |
Gross Profit |
The invoiced without progress amount minus the total cost. |
Profit % |
The gross profit divided by the invoiced without progress amount. |
Effective Rate |
The invoiced without progress amount divided by billed hours. |
Real % |
The invoiced without progress amount divided by WIP amounts billed without write up/down. |
Client Profit Sample Report